package com.hc.fdkgoods.dao;

import com.hc.fdkgoods.common.Result;
import com.hc.fdkgoods.vo.ForwarderSupplierGroupVO;
import com.hc.fdkgoods.vo.ForwarderSupplierVO;
import com.hc.fdkgoods.vo.ForwarderWholeVO_1;
import org.springframework.stereotype.Repository;
import sun.security.ssl.Record;

import java.util.List;

import static com.hc.fdkgoods.db.tables.ForwarderSupplier.FORWARDER_SUPPLIER;
@Repository
public class BaseBusinessInfoDao extends BaseDao{
    /*public ForwarderWholeVO_1 queryAll() {
        List<ForwarderSupplierGroupVO> list=db.selectDistinct(FORWARDER_SUPPLIER.GROUP_NAME).from(FORWARDER_SUPPLIER).fetchInto(ForwarderSupplierGroupVO.class);

        for(ForwarderSupplierGroupVO data:list){
            data.setSupplierVOList(db.select(FORWARDER_SUPPLIER.BUSINESS,
                    FORWARDER_SUPPLIER.CITY,
                    FORWARDER_SUPPLIER.CITY_CODE,
                    FORWARDER_SUPPLIER.FLOOR,
                    FORWARDER_SUPPLIER.FLOOR_CODE,
                    FORWARDER_SUPPLIER.FORWARDER_SUPPLIER_ID,
                    FORWARDER_SUPPLIER.GROUP_NAME,
                    FORWARDER_SUPPLIER.MARKET_CODE,
                    FORWARDER_SUPPLIER.MARKET,
                    FORWARDER_SUPPLIER.SUPPLIER_NAME).from(FORWARDER_SUPPLIER).where(FORWARDER_SUPPLIER.GROUP_NAME.eq(data.getGroupName())).fetchInto(ForwarderSupplierVO.class));
        }
        ForwarderWholeVO_1 f= new ForwarderWholeVO_1();
        f.setList(list);
        return f;

    }*/
}
